Parts of the Northern Beaches of Sydney have been evacuated after Manly Dam spilled over on Tuesday afternoon.